As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
Hi, do you want to check if this field has a value or if this field exists (in other words, if the name of the field is in the Master)?
In the first case you can use IS MISSING (when MIISSING is a possible value) or you can use FIELD EQ ''. In the second case, I don't know. But if you have Master file, you should already know if the name of the field exists.
By default, i want some 10 columns to be displayed in my request. So, if the across field has got only 5 values then i want only the 5 columns to be displayed with Across field value and others as blank.
Also, in my case, i want to position the coulmn according to the across field value. if the across field value is CAR8, then i want CAR8 values to be displayed in 8th column. If it is CAR3 then in 3rd column.
I tried something as follows, COMPUTE P1/A20 = HoldField1; COMPUTE P2/A20 = HoldField2;
It fails when there is no value for across field or no filed in the hold file.
WF 7.7.02 on Windows 7 Teradata HTML,PDF,EXCEL,AHTML