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
In that case, try this
If(Len(Trim(Product_1)) > 0, Product_1, Product) as Product_2
Which is exactly what I posted above... except Product_2 has miraculously become Product_1
Thank you so much for your response, It really helps for me
Thank you so much for your kind response, its really helpful for me.
If in some case i need product_2 Value as SPOT+T when SPOT in product and NULL in Product_1
what i need to edit in the expression that you suggested.
product Product_1 Product_2
SPOT NULL SPOT+T