Merging of Two fields and calling the Result in third Column with Cell Values in separate rows

[ujji]

Hello Everyone,

Hope you can help me with my queries. On that note, i have already attached an Excel with an Example which would brief you my Requirement.

Kindly have a look at it.

Thanks in advance.

[LRuCelver · Accepted solution]

You need to create a third field containing both the Art.Nums and Bezeichnungen. Then you can use a pivot or one or multiple normal tables to display the data:

Here's the script:

Daten:
NoConcatenate Load * Inline [
	Artikel Nummer,	Bezeichnung/Label
	10010,			Stahl
	10020,			Coil
	10030,			Alu Stahl
	10040,			Band Coil
];

Ergebnisse:
NoConcatenate Load
	"Artikel Nummer",
	"Artikel Nummer" as "Ergebnisse/Result"
Resident Daten;
Concatenate Load
	"Artikel Nummer",
	"Bezeichnung/Label" as "Ergebnisse/Result"
Resident Daten;

Join(Daten) Load Distinct * Resident Ergebnisse;
Drop Table Ergebnisse;

[ujji]

Thank you very much. It worked and you have saved me a lot of time.

God bless you 🙂