Cross join

[snassimr]

hi !!!

I need to perform the following task :

A B 2
A C 3
A B 4
A C 1

I need to get all combinations of two first fields with a third field :

A B 1
A B 2
A B 3
A B 4
A C 1
A C 2
A C 3
A C 4

If any easy way to get it in DS ?

[ray.wurlod]

The answer to the question is "yes".

Where are the first two fields coming from? Where is the third field coming from? How do you combine them? We can not give the best answer to your original question without this knowledge.

[snassimr]

first columns are in seq files . For third column I have another seq file.
I can to load both files to DB and do there a cross join . But I want to do it in DS.

I put an example that more clear :

Seq_file 1
A B
A C
Seq_file 2
1
2

I want to get :

A B 1
A B 2
A C 1
A C 2

[peddidsx]

Add another extra column to both the files as KEY and set it to default as '1'.Then Lookup file1 on file 2 based on 'KEY' by setting the option in LookUpStage as to allow duplicates(Allow multiple rows from the reference link).This should result the output as desired.

[rameshrr3]

Then Lookup file1 on file 2 based on 'KEY' by setting the option in LookUpStage as to allow duplicates(Allow multiple rows from the reference link).

Note that this will work only if you create a hashed file of file2 data with UV Stage compatibility [SERVER JOBS]

[ray.wurlod]

Another possibility is to use an ODBC stage, with the DSN using the driver for text files.