Hi everyone,
could you help me solve my problem?
I should start by reading the input file and create an output file.
My problem is how do I build the output file by copying values from the input file?
In the output file I have to copy two values which are in the input file which are:
Name Surname → concatenate them in the AuthorizationProfileName output field
User ID → UserId field of the output file
I am attaching the two files if they can be useful.
I hope you can help me
use ReadRange Activity (workbook flavor) to read InputUser.xlsx.
add a datatrow with AddDataRow named "AuthorizationProfileId" and typed as you need it
add a datatrow with AddDataRow named "AuthorizationProfileName" and typed as String
use ForEachRow Activity (with the previous obtained DataTable).
for each row, Assignrow("AuthorizationProfileName") = row("Name").ToString & " " & row("Surname").ToString
after the ForEachRow, use FilterDataTable and in the second tab, check “keep” and add “UserId”, “AuthorizationProfileId” and “AuthorizationProfileName”.
use WriteRange (workbook flavor) to create your OutUser.xlsx
I don’t know how you get AuthorizationProfileName but you can probably handle it in the loop.
The idea is to work with datatables, adding your target column as needed, fill them according eadh occurence then filter and manage columns before dumping the obtained datatable to a file.
Hi @William_Blech_Sister ,
thanks for the example I will try it soon.
The “AuthorizationProfileId” field is a progressive number but I don’t know how it can be generated so I have to search the forum, do you know what activities to do this thing?
thanks
victory
Hi,
I have tested it and it actually works the only thing is that in the output file there are duplicate lines, is there a way to remove them with a query and leave only one ?
thanks