Hi,
I have a 2 column table: name and value. I would like to use value path (Excel file writing location with file name taken from value RecordID). When I transform table name rows to columns then the dynamic renaming is working.
Is their a chance to get it done without transforming the table?
Thank you.
Résolu ! Accéder à la solution.
Your requirement is really unclear can you please give us more details, sample data and expected output.
We will be happy to help 🙂
name value
RecordID 0815
path \\server\files\output\0815.xlsx|||sh1
Path was generated by Formular:
Add new column path
‚\\server\files\output\‘+tostring([Recordid])‘+.xlsx|||sh1‘
Now I want that the output tool just use the path value for the Excel file. When I transform table like
RecordID Path
0815 \\server\files\output\0815.xlsx|||sh1
Then it is working.
Yes, it was not working. When I transform before in the way that path is a column headline and then when I enter path in the same constellation instead of your shown pic ‚value‘ then it is working.
No, unfortunately not.
Is this the formula you are using for filepath
'\\server\files\output\'+tostring([Recordid])+'.xlsx|||sh1'
Can you check this again.
Really sorry i guess i am still pretty much very unclear about the scenario😶