Extract Year from Data/Time Field

[prashanthi_gn]

Need to create a report on count and list of tables from table of sql statement

[felipe_dutra]

Have you tried this?

Year(Data/Time Field)

[prashanthi_gn]

Hi Felipe_dutra

Thank you very much for the response but the question is about the extracting the table names from a SQL command.

Got posted under the wrong subject.

[felipe_dutra]

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Sc...

[prashanthi_gn]

Let me explain again..

 I have a column called statement where the data will be like " select * from table 1 where ...."

Now I have to pull 'table ' into a separate column.  Statement can have multiple tables (table 1 table 2).. in this case i should get 2 tables from the fields.

[felipe_dutra]

TAB:
LOAD *,
Trim(SubField(TextBetween(Replace(statement,'where',';'),' from ',';'),',')) as Table
Inline [
statement
"select * from table1 where id>100;"
"select * from table2, table3;"
"select * from Customers;"
];