Alteryx Designer

28 februari 2018

Alteryx Designer 11.8 x64 the thrill of solving

 

20180228

Windows desktop operating system Fully functional, ready in 10 minutesBest for blending your own data
bring in the data, do some analysis.
Prepare, blend and analyze all your data using a repeatable workflow
Run predictive, spatial and statistical analytics in one intuitive interface
Combine data from sources like Hadoop, Oracle , Salesforce, Excel and more
Dig into multiple data sources for deeper insights in hours, not weeks

Get ready to Drag. Drop. Solve.

20180228 14daagse trial

the JSON Parse tool separates Java Script Object Notation text into a table schema for the purpose of downstream processing. It can be built back up into usable JSON format by feeding the output into the JSON Build tool.
CREATE TABLE CBSKIS_RELATIE (
   data  CLOB,
  CONSTRAINT CBSKIS_RELATIE_json CHECK (data IS JSON (STRICT))
  
  CREATE TABLE CBSKIS_RELATIE
(BTJBB_RELFISCAALNR VARCHAR2(100),
 BTJBB_RELFISCSUBNR VARCHAR2(100),
 BTJBB_RELEORILANDCD VARCHAR2(100)
 );

);

read JSON file to database

NASA YOUTUBE

PS E:\> sqlplus delhaye/delhaye@orcl

SQL*Plus: Release 12.2.0.1.0 Production on Thu Mar 1 00:17:25 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Last Successful login time: Thu Mar 01 2018 00:16:42 +01:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

SQL> DESCR RELATIE;
Name Null? Type
—————————————– ——– —————————-
JASON_NAME1 NCLOB
BTJBB_RELEORIID NCLOB
BTJBB_RELEORILANDCD NCLOB
BTJBB_RELFISCAALNR NCLOB
BTJBB_RELFISCSUBNR NCLOB

SQL> SELECT COUNT(*) FROM RELATIE;

COUNT(*)
———-
4

SQL> SELECT BTJBB_RELFISCAALNR FROM RELATIE;

BTJBB_RELFISCAALNR
——————————————————————————–
001000469
001000822
001001127
001001437