Automate

Hi Team, 

We use a ME21N and ME41 script, the first line of the script contains the header and the first line of data, the proceeding data lines only contain the data line information, the header cells are blank. 
It's always been my understanding that when using loops the proceeding data lines can't have the header info repeated, the cells need to be left blank, however I have been doing some testing and have found that it does actually work. 

We are using Power BI to stage our data, then extracting into Excel and using the add-in to run the scripts, it takes some trickery to get the blank cells in for the proceeding data lines but if the scripts can handle data being in those cells it's going to make our job so much easier. 

So can it be confirmed that scripts with loops will still work if the header data is repeated on the processing data lines? 

Thanks




------------------------------
Ben
Woodside Energy Ltd
ben.crerar@woodside.com.au
------------------------------

Hi Ben -

Yes, the looped data rows can have the header fields populated in it.  When the script runs an iteration of the loop, it will only pick up data from the fields that are mapped from within the loop. So even if the header fields are populated in the loop row, since header fields are not mapped in the loop iteration, they will simply be ignored.  So it is perfectly fine.  

In general with any script and data file, you can have lots and lots of data in the data file, but unless it is mapped, it will be ignored. 

Thank you!

------------------------------
JENNIFER HWANG | SE
Winshuttle North America
------------------------------

Original Message:
Sent: 10-04-2020 21:38
From: Ben Crerar
Subject: Header and Data lines when looping

Hi Team,

We use a ME21N and ME41 script, the first line of the script contains the header and the first line of data, the proceeding data lines only contain the data line information, the header cells are blank.
It's always been my understanding that when using loops the proceeding data lines can't have the header info repeated, the cells need to be left blank, however I have been doing some testing and have found that it does actually work.

We are using Power BI to stage our data, then extracting into Excel and using the add-in to run the scripts, it takes some trickery to get the blank cells in for the proceeding data lines but if the scripts can handle data being in those cells it's going to make our job so much easier.

So can it be confirmed that scripts with loops will still work if the header data is repeated on the processing data lines?

Thanks




------------------------------
Ben
Woodside Energy Ltd
ben.crerar@woodside.com.au
------------------------------