Concatenate/join multiple records into one

[pho3nix90]

I want to import a table file (text file), but instead of showing a record for each line, I want the whole file to be one record? is this possible?

[#2]

Hi Pho3nix90,

you can summarize the table if all the dimesions are equal and group it by all the dimensions.

But I don't know how your file looks like.

Hope it helps,

Regards,

Reyman

[pho3nix90]

Hi Reyman,

Thanks for your reply, basically I am importing a qvw log file, only field is @1, and about +- 1000 records, but I need it as 1 record.

[#4]

If there is only one field, you can load the max of it or load distinct

Else you should aggregate it. Either SUM, MIN, ONLY, MAX or AVG.

QV help:

distinct is a predicate used if duplicate combinations of values in the selected fields only should be counted once.

These functions can only be used in field lists for load statements with a group by clause.

The aggregation functions are:

Basic aggregation functions
sum	only	mode
min	max	firstsortedvalue

Hope this helps, else you should give me an example of how it should look like, with some fake values.

Regards,

Reyman

[#5]

You can load all the records and apply concact function to get single value. Hope it helps you.

Regards,

Kiran.

[pho3nix90]

Here are the example, first one is the original "table" with the numbers to the left, the record number, I want it to be like the seconf example

example1:

          @1

1. value 1
2. value 2
3. value 3
4. value 4
5. value 5
6. value 6

example2:

          @1

1. value 1
   value 2
   value 3
   value 4
   value 5
   value 6
   
   

so basically all the records must be 1 record? hope this makes sense.

[#7 · Accepted solution]

Do you mean something like attached example?

Rgds Reyman

[pho3nix90]

Yeah thats it, thanks alot, going to try it now.