Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to create a new column (TXT_EXPORT.ARGUMENT_05).Pls see the script and i have applied if condition
if(Num(TXT_EXPORT.ARGUMENT_051) > 10, TW_SP_BO.Reservoir_Pressure, "1*") as TXT_EXPORT.ARGUMENT_05
but it is not giving desired numerical result of TW_SP_BO.Reservoir_Pressure instead giving some string
Any one pls help me .I have reduced the data sorry 4 dat pls refer the screenshot it is hows is the data
Thanks all for your continuous support and apolgy for hurting anyone my issue has been resolved .It was error in requirement.
Is it necessary to post a 36M attachment?
Use a "Straight Table" and enter an expression like
IF([Item 10] > 10 AND [Item 5] > 10, TW_SP_BO.Reservoir_Pressure, '1*')
Peter
But Item 5 and Item 10 are never greater than 10?
Hi Sunny ,
I have reduced the data
Can you reduce your file in such a way that we can see few of the rows where these numbers show up?
Got it.... so I see this script
Temp:
Load if( num(TXT_EXPORT.ARGUMENT_05) > 10, "TW_SP_BO.Reservoir_Pressure",'1*') as TXT_EXPORT.ARGUMENT_015
Resident TXT_EXPORT;
You are creating a new field called TXT_EXPORT.ARGUMENT_015... but I don't even see it in the application... TXT_EXPORT.ARGUMENT_05 isn't changing, but it is used to create a new field... is this what are hoping to do?
It is used to create a new field. ..any other suggestions
Exactly sunny any other ways to do so..
May be change it in the same table
TXT_EXPORT:
LOAD
if( num(TXT_EXPORT.ARGUMENT_05) > 10, "TW_SP_BO.Reservoir_Pressure",'1*') as TXT_EXPORT.ARGUMENT_05,
.....
FROM...
We all here help each other. I've received lot of "Prompt and correct" help from users that are at top level and particularly from Sunny. He has been very prompt, tries to understand the problem we have and provides solution that has worked almost every time I've posted a question.