Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table Product_group, which contain 2 column
Product Product_2
SPOT SPOT-T
FIX ---------
TOM ----------
SPOT SPOT-T1
SPOT SPOT-T2
i need to add third column DETAILED_PRODUCT which should look as below
DETAILED_PRODUCT
SPOT-T
FIX
TOM
SPOT-T1
SPOT-T2
where SPOT need to split in third column like where ever SPOT in Product column should be replace by Product_2.
Please help me with this. thank you
If(Len(Trim(Product_2))>0,Product_2,Product) as Product_3
In that case, try this
If(Len(Trim(Product_1)) > 0, Product_1, Product) as Product_2
If(Len(Trim(Product_2))>0,Product_2,Product) as Product_3
there is some data in Product_2 in place of null
Thank you sunny,
I am in confusion. In the new column i want Product data where SPOT should replace in the Product_2 column data.
like where SPOT appear in product column should replace by Product_2 .
Is your script works as same.
Thank you in advance.
I have Product Product_1 need Product_2 as below
Product Product_1 Product_2
SPOT SPOT_T1 SPOT_T1
FIX ----- FIX
-------- TOM TOM
SPOT SPOT-T2 SPOT-T2
SPOT SPOT-T3 SPOT-T3
---------- ---------- ---------------
TOM FAT TOM
according the above i need Product_2 in new column. can you please help me with this.
---- its null