dtk | data toolkit ) is a suite of tools

I got my new Macbook Pro which has M1 chip.

I tried to run my react native project but stucked on pod install.

After that, I created an empty project and tried on that still getting the same error.

I am trying to set up Google SSO.

My Podfile looks like this:

I am trying to develop an iOS application with swift having a custom cells in UItableview.

1 - my controller's (personalinformation) codes :

I need to aggregate STRUCTs into an array where the two fields within the STRUCT can be null (they will either both be null nor neither). Using IGNORE NULLS in the ARRAY_AGG function doesn't work - is there a way to take these null rows out of the resulting array?

My table looks like this:

And I want my output to look like this, but excluding the null values within the STRUCTs:

Where there is no value for label, language or dtk I still want to include the row but with a blank array - this means I can't prefilter the nulls out as this will result in rows being excluded.

The query I am currently using to get this output looks like this:

i want to extract comments from a website, with this code i success to extract comments.

I thank all of you for your precious time. I would like to have a table with the first column with no lag, the second column with one lag down, the third column with two lags down, etc., as in the picture. I have code that actually does the job but only if you run the code once. If you run the code two or three times you will notice that additional shifts (lags) occur. I would be very grateful if any of you could help me get the same result no matter how many times the code is run.

Screenshot: