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.
Solved! Go to 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😶