dynamic name excel file 2 column table

[stefankremer]

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.

[atcodedog05]

Hi @stefankremer 

Your requirement is really unclear can you please give us more details, sample data and expected output.

We will be happy to help 🙂

[stefankremer]

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.

[atcodedog05]

Hi @stefankremer 

Have you checked this option

[atcodedog05]

@stefankremer 

Or sorry maybe you were trying say something else. I might be still bit unclear.

[stefankremer]

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.

[atcodedog05]

@stefankremer 

So is the issue solved or not😅

[stefankremer]

No, unfortunately not. 

[atcodedog05]

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😶 

[stefankremer · Accepted solution]

Hi, I found the solution by myself 😉 Attached you will find it. Sorry, it was an understanding or a logical problem and not knowing how the tools are working. Thank you so much for inspiring me.