if only the machine is working i mean in case of Y
make table 1 in the 3rd row in sheet called machine
and include only in the table machine and working column
if working no ,make second table under last row in the first table 7 rows down
and also make new sheet called amount
it will has table year and amount columns if the machine working is y
Thanks in advance
+2
@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
+17
@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.
@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.
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
@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
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
+17
@soly, thanks for sharing the Excel files. I think this workspace is close to your requirement.
convert-tables.fmwt (FME 2019.2)
[Upgrade] 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,@soly, thanks for sharing the Excel files. I think this workspace is close to your requirement.
convert-tables.fmwt (FME 2019.2)
[Upgrade] 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,thanks a lot ,iam working on it nw but u helped me alot
@soly, thanks for sharing the Excel files. I think this workspace is close to your requirement.
convert-tables.fmwt (FME 2019.2)
[Upgrade] 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,@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
+17
@soly, thanks for sharing the Excel files. I think this workspace is close to your requirement.
convert-tables.fmwt (FME 2019.2)
[Upgrade] 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,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.
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.