Hello all,
I have been trying to setup blank values in an Import Scenario. The requirement is mentioned in the table below.
| Reference |
| Value1 |
| (Blank row) |
| Value2 |
| Value 3 |
What kind of condition would be applied so that the system would leave the second row (blank row) as blank while enter the data in the rest of the rows?
Thank you.
Best answer by totochow
I might be wrong but it seems that your IIF formula is missing something. Try to click the pencil icon to validate your formula…
usually IIF is like:
= IIF (“YOUR T/F TEST CASE HERE”, “ACTION IF TRUE”, “ACTION IS FALSE”)
+13Hi@harshit
Could you please share more information, Give me the scenario and Import scenario you want to update the values,
if you want to pass blank detais then you import scenario should have Null https://www.augforums.com/forums/everything-else/setting-a-field-to-empty-or-null/
Hi
If the destination column where you are trying to import a value allows ‘Null’ value, then just leaving the source data column blank should leave the column value empty/ Null.
To insert empty value to columns, one can use =Null on mapping.
Hope this helps,
Regards,
Thank you
I have attached the sheet of the data which needs to be imported below. i would like to import the data into Invoices and Memos form:
Hi
If the destination column where you are trying to import a value allows ‘Null’ value, then just leaving the source data column blank should leave the column value empty/ Null.
To insert empty value to columns, one can use =Null on mapping.
Hope this helps,
Regards,
Thank you
Well the field isn’t allowing any “NULL” value, and my column consists of the rows with blank values and some with data. For eg: my first row would have some data, whereas second row would be a blank field, third row might have some data and so on..
I might be wrong but it seems that your IIF formula is missing something. Try to click the pencil icon to validate your formula…
usually IIF is like:
= IIF (“YOUR T/F TEST CASE HERE”, “ACTION IF TRUE”, “ACTION IS FALSE”)
I might be wrong but it seems that your IIF formula is missing something. Try to click the pencil icon to validate your formula…
usually IIF is like:
= IIF (“YOUR T/F TEST CASE HERE”, “ACTION IF TRUE”, “ACTION IS FALSE”)
Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
