Excel input file Colums issue

Help Activities
, ,
1

Hi Team,

I have an Input file attached below which downloads from application
Sample Input file.xlsx (13.5 KB)

Issue 1:
Can i read the headers because i can see headers in 2 rows? can you please help me with the solution.

Issue 2
The record ID Columns we have multiple. i want to take first Record ID column remaining should be removed

Thanks
Likitha

2

Hi,

How about the following sample? This solves both issues.

image
image1217×2311 158 KB

Sample20230618-1aL.zip (14.0 KB)

Regards,

3

From the above input file the A1 Row should get deleted and input file should start from A2 for next furthur steps(Example Parts,Labour etc sholud get deleted which is in the first row)
can you please provide the solution

Hi @Yoichi i didnt tested the above xaml. please confirm the above thing bot will do or it is giving different output of excel

Thanks
Likitha

4

Hi,

The above sample workflow outputs the following datatable : basicallyeach item of the 2nd row becomes columnname and RecordID columns are removed except the first one. Can you try this?

image
image1122×86 3.11 KB

Regards,

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.