+9I have an excel spreadsheet where the attribute name changes based on a formula, every time we fill in an X in line 2 the attribute has the same name, but the number can change to 1,2,3 and 4. I created a reading dynamic, but when for example the COD_STREET = 0 in the dynamic FME reader keeps showing COD_GATE = 4 in one of the attributes, what am I doing wrong?
attachment follows the spreadsheet
Best answer by markatsafe
@mr_fme It would be hard to believe that FME could not help resolve this unusual case. Understanding the initial question helps.
I've attached an example workspace (FME 2021.1):
+59One option would be to not read in the first line with attribute names, that way FME will name them A, B, C etc. (corresponding with the Excel column letters). As long as the schema doesn't change (i.e. it's always the same column you need, regardless of its name) it should work.
+9One option would be to not read in the first line with attribute names, that way FME will name them A, B, C etc. (corresponding with the Excel column letters). As long as the schema doesn't change (i.e. it's always the same column you need, regardless of its name) it should work.
Sorry, no work for me.
@mr_fme I think a little more detail on the problem you're trying to solve would help us. Your headers are merged cells - but FME will read each actual column corresonding to the Excel columns A,B,S, etc. Perhaps you can show us what you'd like to read from the spreadsheet. What would you expect if a second row is added to the spreadsheet? Can you explain why @Hans van der Maarel suggestion of using the the column letters doesn't work for you?
+9@mr_fme I think a little more detail on the problem you're trying to solve would help us. Your headers are merged cells - but FME will read each actual column corresonding to the Excel columns A,B,S, etc. Perhaps you can show us what you'd like to read from the spreadsheet. What would you expect if a second row is added to the spreadsheet? Can you explain why @Hans van der Maarel suggestion of using the the column letters doesn't work for you?
Hi @Mark Stoakes
For example, I have the information regarding the image below:
I need to extract the value of these columns, in this case each X represents the sum of a number 1.
I need to transform with FME Desktop in this result below:
Or at least a result like this:
With all the power FME has it's hard to believe you can't transform using it.
Thank´s
@mr_fme It would be hard to believe that FME could not help resolve this unusual case. Understanding the initial question helps.
I've attached an example workspace (FME 2021.1):
+9@mr_fme It would be hard to believe that FME could not help resolve this unusual case. Understanding the initial question helps.
I've attached an example workspace (FME 2021.1):
uhuuu good, very good. Helped a lot.
Thank´s
+9@mr_fme It would be hard to believe that FME could not help resolve this unusual case. Understanding the initial question helps.
I've attached an example workspace (FME 2021.1):
@Mark Stoakes
One question more....How do I transform rows into columns, however by attr_name ie CAR_UNIT, CAR_GATE....??
Thank´s
