Spool a JSON file into a table

Anonymous — Fri, 10 Jan 2020 16:28:29 GMT

Hi all,

i have the next JSON file:

{
"store":	[
				{
					"name": "Sunshine Department Store",
					"address": "Wangfujing Street",
					"goods":	[
									{
										"book":	[
													{
														"category": "Reference",
														"title": "Sayings of the Century",
														"author": "Nigel Rees",
														"price": 8.88
													},
													{
														"category": "Fiction",
														"title": "Sword of Honour",
														"author": "Evelyn Waugh",
														"price": 12.66
													}
												]
									},
									{
										"bicycle":	[
														{
															"type": "GIANT OCR2600",
															"color": "White",
															"price": 276
														}
													]
									}
								]
				}			
			]
}

I would like to have the next table:

StoreName	StoreAddress	Good_Type	Category	Title	Author	Price	Type	Color
Sunshine Department Store	Wangfujing Street	Book	Reference	Sayings of the Century	Nigel Rees	8.88	NULL	NULL
Sunshine Department Store	Wangfujing Street	Book	Fiction	Sword of Honour	Evelyn Waugh	12.66	NULL	NULL
Sunshine Department Store	Wangfujing Street	Bicycle	NULL	NULL	NULL	276	GIANT OCR2600	White

Is this possible? I was trying a lot but i cannot figured it out!

Thanks in advance!

Re: Spool a JSON file into a table

Anonymous — Mon, 13 Jan 2020 07:00:35 GMT

Hi
There are two loop elements in this json file, using two tFileInputJson components to read each loop element separately, one for Book node and another for bicycle node, and then do an inner join on tMap to merge the two flow on based on field Stored Name, the job design looks like:
tFileInputJson--main---tMap--->
|lookup
tFileInputJson

Regards
Shong

topic Spool a JSON file into a table in Talend Studio

Spool a JSON file into a table

Re: Spool a JSON file into a table