topic Re: Concatenate unrelated fields - default field in QlikView

Concatenate unrelated fields - default field

ivandrago — Sat, 26 Sep 2015 08:46:35 GMT

HI,

I have two tables I am going to concatenate together, what should my default values be for dates, characters and values when I have fields that don't exist in one of the tables?

Thanks

‌

Re: Concatenate unrelated fields - default field

MarcoWedel — Sat, 26 Sep 2015 09:04:06 GMT

please post sample data for both tables.

regards

Marco

Re: Concatenate unrelated fields - default field

marcus_sommer — Sat, 26 Sep 2015 09:29:09 GMT

The fields which belonged together and contain the same content should have the same field-names and formattings. By the other fields isn't this really important:

Data Types in QlikView

On Format Codes for Numbers and Dates

- Marcus

Re: Concatenate unrelated fields - default field

evan_kurowski — Sat, 26 Sep 2015 16:24:21 GMT

Hello Ivan Drago,

Forgive me, but... I must break you... by agreeing as has been pointed out, if you are combining just two tables and there is a section where only one of the tables has extra fields, you don't need to do anything extra for their data types, just load them in with their current formats unchanged.

However, when you start sequencing from many sources, it becomes helpful to remember the "first touch" principle, where the first load statement for a concatenated field "casts" it for all subsequent loads. I put together an illustration that should cover some examples:

Re: Concatenate unrelated fields - default field

Digvijay_Singh — Sat, 26 Sep 2015 17:00:09 GMT

Hi,

Qlikview will put Null in the fields not available in other table, I think it doesn't matter what is the type of fields whether date, char which doesn't exists in other table as all such values will be null. Not sure if I understood the question.

TableA:

Field A, Field B

AAA, BBB

Concatenate

TableB:

Field A, Field C

AAA1, CCC

Output:

TableA:

Field A, Field B, Field C

AAA, BBB, -(Null Symbol)

AA1, -(Null), CCC

Re: Concatenate unrelated fields - default field

Anonymous — Sat, 26 Sep 2015 17:39:15 GMT

Null.