topic Re: how to add a condition column in the loading script in Connectivity & Data Prep

how to add a condition column in the loading script

emilyrabbit — Wed, 28 May 2025 07:48:07 GMT

HI, below is my origin data.

there are different product in each order

in the loading script , I want to add a new column , if the product contain 'cat' ,and the order should be remark as 'cat order' . I wonder if I can use mapping load or left join. but I am not familiar with these 2 expression. Pls help me on it, thanks.

below is the target :

Re: how to add a condition column in the loading script

Adam_Romanowski — Wed, 28 May 2025 08:56:02 GMT

LOAD

[Order],

[Order line]

[Product],

if(Product='cat', 'cat order', 'not cat order') as [Order type]

from ...

Re: how to add a condition column in the loading script

emilyrabbit — Thu, 29 May 2025 01:06:54 GMT

Hi , the result is not correct. C contains "cat" , but order type still show "not cat order"

Re: how to add a condition column in the loading script

emilyrabbit — Thu, 29 May 2025 01:08:42 GMT

@MatheusC can you also help me check it ?Thanks.

Re: how to add a condition column in the loading script

Aditya_Chitale — Thu, 29 May 2025 04:52:11 GMT

@emilyrabbit

Maybe there are empty spaces in the column values. try using below expression:

if(wildmatch(trim(Product),'cat'), 'cat order', 'not cat order') as [Order type]

Regards,

Aditya

Re: how to add a condition column in the loading script

emilyrabbit — Thu, 29 May 2025 05:10:42 GMT

Hi， for some order line , there is not "cat" ,for instance ,C2 & C2 , but for the C order , it should show "cat order" . it isn't the match expression.

Re: how to add a condition column in the loading script

Aditya_Chitale — Thu, 29 May 2025 05:40:23 GMT

@emilyrabbit

Are you looking for something like this ?

test: //Load Base table LOAD "Order", Product FROM [lib://TestFolder/Sales Test.xls] (biff, embedded labels, table is Sheet1$); left join (test) //concat all products grouped on basis of order and //left join with base table Load "Order", concat(trim(Product),'|') as IsCat Resident test group by "Order"; NoConcatenate //use if condition to determine order type as a whole based on //order final: load "Order", Product, if(wildmatch(IsCat,'*Cat*'),'Cat Order','not cat order') as "Order Type" Resident test; Drop table test;

Output:

Regards,

Aditya

Re: how to add a condition column in the loading script

MatheusC — Thu, 29 May 2025 12:01:18 GMT

I'm a little late.

Did you manage to solve it? It seems like @Aditya_Chitale solution is what you're looking for, or is there something else I might be missing?

Re: how to add a condition column in the loading script

emilyrabbit — Fri, 30 May 2025 01:52:43 GMT

thanks . I found the solution ,using the mapping loading .