I want to join 2 views.First view is created from Json file and second view is created from delimited files(Text Files)
I need to join both of them on basis of one coloumn.
This column can be easily written by specifying view name and then col name followed by dot operator.Like JsonView.SampleId.
But this column name is present in key coulmn inside delimited view(Delimited view has always key, value pair ) Means key coulmn has name like sampleId and then Value coulmn has its value.
Now challenge is when I am trying to specify this condition on join condition then I could not map key coloumn name of delimited file Like
Suppose first View(JsonView) has value like:
Second View(Delimited data source view) have following colmns in its view
Now I want to join both view on basis of Sample Id.I am writing VQL join condtion like this
FROM bv_JsonView AS bv_JsonView INNER JOIN bv_delimitedView AS bv_delimitedView ON bv_JsonView.samplesId= max(case WHEN (bv_delimitedView.key = 'Sample ID') THEN (select bv_delimitedView.value) AS SampleId.
Please let me know what mistake I am doing.
Thanks in Advance.