@soly the FME Desktop training would help answer many of these questions - there are many training options. There are also tutorials on working with Excel data.

In this specific case - you probably want to use a Testfilter transformer to split the original table into Y|N and then using the Excel writer to write the two sets of data to 'machine' and 'amount' sheets

@soly, if you would post additional screenshots which illustrate your desired result (i.e. the two tables that should be created from the example table), it would help us to understand the requirement correctly.

machine.xlsx

result.xlsx

i want to extract 3 tables at the same sheet

first table that include year in result file come from year table in machine ,if machine is working it should get only 4 digit of year and duplicate years and count how many years duplicatied then sum of this count as shown in example .

second table it comes from level column and level_year column in machine file ,and if the machine is working and also level cell is not empty so get each cell level and write the duplicate year beside it and count the years and sum the count. as shown in example

third table

f the machine is working,Make ID column from M column in machine file and rename m to ID.then count working cells.

may be the input excel file as machine file will change with another values but the input files always the same header

Thanks for helping and asking

machine.xlsx

result.xlsx

this is two excel that am i working on it ,if u can help and thanks alot

i want to extract 3 tables at the same sheet

first table that include year in result file come from year table in machine ,if machine is working it should get only 4 digit of year and duplicate years and count how many years duplicatied then sum of this count as shown in example .

second table it comes from level column and level_year column in machine file ,and if the machine is working and also level cell is not empty so get each cell level and write the duplicate year beside it and count the years and sum the count. as shown in example

third table

f the machine is working,Make ID column from M column in machine file and rename m to ID.then count working cells.

may be the input excel file as machine file will change with another values but the input files always the same header

@soly, thanks for sharing the Excel files. I think this workspace is close to your requirement.

convert-tables.fmwt (FME 2019.2)

EUpgrade] convert-tables-2.fmwt (FME 2019.2)

The approach is: firstly create a csv table below, read back it then write into an Excel file.

A,B,CMachine,,YEAR,Count,1905,3,1990,4,2004,1,2005,1,2017,1,2018,1,2019,1,2020,1,Result,13,level,,level,year,count10 m,1920,110 m,2010,111 m,1920,111 m,2007,111 m,2010,111 m,2020,212 m,2005,112 m,2010,112 m,2020,1Result,,10M,,ID,working,1,y,2,y,3,y,4,y,5,y,6,y,8,y,9,y,12,y,15,y,16,y,18,y,19,y,Result,13,

A,B,CMachine,,YEAR,Count,1905,3,1990,4,2004,1,2005,1,2017,1,2018,1,2019,1,2020,1,Result,13,level,,level,year,count10 m,1920,110 m,2010,111 m,1920,111 m,2007,111 m,2010,111 m,2020,212 m,2005,112 m,2010,112 m,2020,1Result,,10M,,ID,working,1,y,2,y,3,y,4,y,5,y,6,y,8,y,9,y,12,y,15,y,16,y,18,y,19,y,Result,13,

thanks a lot ,iam working on it nw but u helped me alot 

A,B,CMachine,,YEAR,Count,1905,3,1990,4,2004,1,2005,1,2017,1,2018,1,2019,1,2020,1,Result,13,level,,level,year,count10 m,1920,110 m,2010,111 m,1920,111 m,2007,111 m,2010,111 m,2020,212 m,2005,112 m,2010,112 m,2020,1Result,,10M,,ID,working,1,y,2,y,3,y,4,y,5,y,6,y,8,y,9,y,12,y,15,y,16,y,18,y,19,y,Result,13,

@takashi

first thanks really for ur help .

i want to ask because iam using fme 2018 and i think u r using the latest version 2019

so some transformer are disappeared

but in Attribute manager i got ur idea thanks alot for that but i want to ask where did u get Date as input

i was trying to find location of missing transformer

tester before attribute manager

static calculator was before sorter ,for count

but iam not sure about Aggregator ,does it locate before attribute creator .if yes, so which parameter should i do for that .

or could u provide me the example ,to work on version 2018 .

i want to ask about sth else , to copy 3 column to excel writer under these tables without changes ,which transformer should i use bcs i have read that there is issue to copy column without any effect ,am i right or it was old topic since some years and now fme has not this problem any more and thanks alot for helping

A,B,CMachine,,YEAR,Count,1905,3,1990,4,2004,1,2005,1,2017,1,2018,1,2019,1,2020,1,Result,13,level,,level,year,count10 m,1920,110 m,2010,111 m,1920,111 m,2007,111 m,2010,111 m,2020,212 m,2005,112 m,2010,112 m,2020,1Result,,10M,,ID,working,1,y,2,y,3,y,4,y,5,y,6,y,8,y,9,y,12,y,15,y,16,y,18,y,19,y,Result,13,

convert-tables-2-fme2018.1.fmwt (FME 2018.1)

The "Type is" operator in the Tester doesn't support the operand "Date" in FME 2018 and earlier. You have to use other operator, e.g. Contains Regex in this case.

Please mention what version of FME you are using whenever you would ask a question, in order not to waste our time. If you didn't mention the version, we assume that you are using the latest version of FME at the time.

Sry that i forget to say my version and thanks alot