Automate

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

Hi,
I have watched the training video and read the documentation.
I was able to record and map as suggested and all runs ok. The problem is I cannot get the syntax on the IF correct, I have tried both column and SAP field = blank but it will not work if the field is blank, how do I get to 'END'.

I would have thought it would be something like
"IF XXXXX  (SAP field or column) is blank END, ELSE run script for the next set of values and repeat the above.

Any help would be appreciated.
Regards
Rob

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

Hi,
I have watched the training video and read the documentation.
I was able to record and map as suggested and all runs ok. The problem is I cannot get the syntax on the IF correct, I have tried both column and SAP field = blank but it will not work if the field is blank, how do I get to 'END'.

I would have thought it would be something like
"IF XXXXX  (SAP field or column) is blank END, ELSE run script for the next set of values and repeat the above.

Any help would be appreciated.
Regards
Rob

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

Hi,
I have watched the training video and read the documentation.
I was able to record and map as suggested and all runs ok. The problem is I cannot get the syntax on the IF correct, I have tried both column and SAP field = blank but it will not work if the field is blank, how do I get to 'END'.

I would have thought it would be something like
"IF XXXXX  (SAP field or column) is blank END, ELSE run script for the next set of values and repeat the above.

Any help would be appreciated.
Regards
Rob

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

Hi,
I have watched the training video and read the documentation.
I was able to record and map as suggested and all runs ok. The problem is I cannot get the syntax on the IF correct, I have tried both column and SAP field = blank but it will not work if the field is blank, how do I get to 'END'.

I would have thought it would be something like
"IF XXXXX  (SAP field or column) is blank END, ELSE run script for the next set of values and repeat the above.

Any help would be appreciated.
Regards
Rob

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

Hi,
I have watched the training video and read the documentation.
I was able to record and map as suggested and all runs ok. The problem is I cannot get the syntax on the IF correct, I have tried both column and SAP field = blank but it will not work if the field is blank, how do I get to 'END'.

I would have thought it would be something like
"IF XXXXX  (SAP field or column) is blank END, ELSE run script for the next set of values and repeat the above.

Any help would be appreciated.
Regards
Rob

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

• Please confirm which tcode you are using.  We might be able to record it differently, as some of the forecast tcodes have multiple columns of data, but it will depend on the tcode.
• You could use a macro to reformat the data.

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob

• Please confirm which tcode you are using.  We might be able to record it differently, as some of the forecast tcodes have multiple columns of data, but it will depend on the tcode.
• You could use a macro to reformat the data.

Hello Community experts,

I have a question about trying to use a loop across a single line of a spread sheet.

The scenario is that although most of our customers send in EDI forecasts that update their sales schedule agreement (SA) automatically some of them send in spreadsheets for forecast data that the business would like to upload. The issue is that the header data and item data would be on the same line, is it possible to have the SA header data which would be the header and the forecast dates (loop) on the same line.

I know that the normal way to do the loop on a seperate line but we need reduce the amount of pre work that is done to the spreadsheet to prepare it for loading as it defeats the object of using the Winshuttle upload.

See enclosed example
Thanks in advance

Rob