topic Re: Create a calculated field after a Binary Load in App Development

Create a calculated field after a Binary Load

Ray123 — Sat, 16 Nov 2024 00:21:43 GMT

Hi Experts,

I have a (in my view) straight forward question. Although I couldn't find the answer anywhere...

Q: How can I create a calculated field, after a binary load?

Just Imagine that my code is this:

Binary [lib://DailyManagement - my_test.qvw];

And that it has a dimension, called 'Country' .

How can I create 'Country_2' which only replaces 1 value (NULL value to the text 'No value')

Many thanks in advance!

Re: Create a calculated field after a Binary Load

Frank_Hartmann — Fri, 26 Mar 2021 15:46:29 GMT

Maybe like this:

BINARY test.qvw; SET ThousandSep='.'; SET DecimalSep=','; SET MoneyThousandSep='.'; SET MoneyDecimalSep=','; SET MoneyFormat='#.##0,00 €;-#.##0,00 €'; SET TimeFormat='hh:mm:ss'; SET DateFormat='DD.MM.YYYY'; SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]'; SET FirstWeekDay=0; SET BrokenWeeks=0; SET ReferenceDay=4; SET FirstMonthOfYear=1; SET CollationLocale='de-DE'; SET MonthNames='Jan.;Feb.;März;Apr.;Mai;Juni;Juli;Aug.;Sep.;Okt.;Nov.;Dez.'; SET LongMonthNames='Januar;Februar;März;April;Mai;Juni;Juli;August;September;Oktober;November;Dezember'; SET DayNames='Mo.;Di.;Mi.;Do.;Fr.;Sa.;So.'; SET LongDayNames='Montag;Dienstag;Mittwoch;Donnerstag;Freitag;Samstag;Sonntag'; NULLASVALUE Country2; SET NullValue = 'No value'; NoConcatenate Final: Load *, Country as Country2 Resident test;DROP table test;

Re: Create a calculated field after a Binary Load

rwunderlich — Fri, 26 Mar 2021 17:58:43 GMT

After Binary, all the tables will be in memory so you can reference them in a Load statement using the Resident keyword. So if "Country" is in a table named "Countries" something like:

Left Join(Countries)
LOAD *, if(len(Country) = 0, 'No Value', Country) as Country2
Resident Countries
;

Or any other kind of Load, NullAsValue, etc.

-Rob