I have been trying to create an import scenario for SO where I have 4 columns from which the data is to be inserted. Out of these 4 columns it is not necessary that the data from these 4 columns are required to be inserted.
So as per the above screenshot, for row 1, the value under book1 should be inserted. Similarly, for last row the value under book1 & book2 columns should be inserted while the other should be skipped. For a single row an individual order would be made.
What condition can be inserted so that the cells where ‘-’ sign is inserted will not be inserted and be skipped in the import scenario?
Thanks.
Best answer by riglesias
Hi @Harry,
If you map Line Number line to =-2 it will delete lines from the grid (see webinar from link below with detailed example min 57:58) If you need to add multiple lines under details for a single document, you need to have one line per item for the same document number. Like this:
Here’s the webinar where I clarify mapping Line number line to =-2 deletes lines from a grid:
Have you tried using iif expression? IIf( expr, truePart, falsePart ) Something like this IIf( [Book2]=’-’, ‘’, [Book2])
Here’s is the import scenario:
Where Dummy Item is a non stock that has been created in the system and this dummy item is placed where the cell is empty with value ‘-’ So can you guide me to where shall I be adding the iff expression you’ve shared?
In my expression, for the true part I typed ‘ ‘ so the fields that have the ‘-’ value would be replaced by a blank space. If you need to select the dummy item instead, change the ‘ ‘ true part with ‘Dummy Item’. In your mapping, under Inventory ID line, under Field/Action Name column try this: IIf( [Book2]=’-’, ‘Dummy Item’, [Book2])
In my expression, for the true part I typed ‘ ‘ so the fields that have the ‘-’ value would be replaced by a blank space. If you need to select the dummy item instead, change the ‘ ‘ true part with ‘Dummy Item’. In your mapping, under Inventory ID line, under Field/Action Name column try this: IIf( [Book2]=’-’, ‘Dummy Item’, [Book2])
Hey @riglesias , shall I add this above the Line Number -2 condition of the Inventory ID?
If you map Line Number line to =-2 it will delete lines from the grid (see webinar from link below with detailed example min 57:58) If you need to add multiple lines under details for a single document, you need to have one line per item for the same document number. Like this:
Here’s the webinar where I clarify mapping Line number line to =-2 deletes lines from a grid:
If you map Line Number line to =-2 it will delete lines from the grid (see webinar from link below with detailed example min 57:58) If you need to add multiple lines under details for a single document, you need to have one line per item for the same document number. Like this:
Here’s the webinar where I clarify mapping Line number line to =-2 deletes lines from a grid:
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
