Excel Automation using specific conditions

Help Studio
, ,
1

Hi all,

I’ve to copy data from one Excel sheet and insert into another one, with specific format conditions.

Input data is:

image
image809×82 4.41 KB

Output conditions are:

  1. If “Alias” is present the output data should contain 6 Rows.
  2. If “Alias” is not present output data should contain 4 Rows

Example:

For 1st condition…

image
image1323×160 8.69 KB

For 2nd condition…

image
image1322×124 6.78 KB

Thanks in advance…

2

You can use for each row to loop through your input DT. Use get row item to capture the value of column " Alias" . Check if that value is empty or not , then depending on the result , you can choose between the number of rows to add to the Output DT.

3

Can you send the sample input file, @Abhishek_Changan

4

Excel Automation.xlsx (11.8 KB)

5

Excel File with I/O:

Excel Automation.xlsx (11.8 KB)