topic Combining 2 fields from excel in QlikView

Combining 2 fields from excel

ljames88 — Wed, 25 Nov 2020 16:16:04 GMT

I need to combine a number field and a string field together to create a new field. I am having issues since they are different types, any suggestions..

For example Field 1 = 1920394

Field 2 = UGA

want to create 1920394UGA

Re: Combining 2 fields from excel

Anonymous — Thu, 22 Sep 2016 16:46:30 GMT

In Excel you need to convert the number to text, then combine them.

A1=1920394, B1=UGA

The Text function needs a format and "#" says it displays the numerals.

Formula:

=TEXT(A1,"#")&B1

1920394UGA

This also works with dates. Copy the date formatting from the Custom formats when you select Format Cell. You can vary as needed.

Re: Combining 2 fields from excel

Anonymous — Thu, 22 Sep 2016 17:01:26 GMT

Field1 & Field as Newfield

In the load script.

Re: Combining 2 fields from excel

Anonymous — Thu, 22 Sep 2016 17:04:49 GMT

LOAD A,
B,
A & B AS NEWFIELD
FROM
[\\test data.xlsx]
(ooxml, no labels, table is Sheet1);