Vector multiplication with Strings

hospitalfinance — Wed, 11 Aug 2021 10:14:37 GMT

Good afternoon,

i have a problem that i can not solve on my own.

I want to create a data model with two tables, which I already loaded. Table A and Table B. My target should be Table C with two columns, which include all combinations of Table A and Table B.

Table A:

Person1

Person2

Table B:

01.01.1990

01.02.1990

Target Table C:

Person1 01.01.1990

Person1 01.02.1990

Person2 01.01.1990

Person2 01.02.1990

I hope that you can give me al solution.

Best regards.

Re: Vector multiplication with Strings

Taoufiq_Zarra — Wed, 11 Aug 2021 10:35:21 GMT

@hospitalfinance

you can just add a join between two table

TableA: load * inline [ Person Person1 Person2 ]; join TableB: load * inline [ Date 01.01.1990 01.02.1990 ];

output:

topic Vector multiplication with Strings in QlikView

Vector multiplication with Strings

Re: Vector multiplication with Strings