jkl | static site generator written in Go | Static Site Generator library

I have this extremely messed up dataframe:

...

There is the following DataFrame:

...

I have an array, say @array1 = qw(abc def ghi jkl).

Now, I want to use this array in a way that elements are shifted 1 by 1, but that shifting takes place virtually, and not in the array.

Like, "shift" will shift the elements and remove them from the array. But, I don't want those elements to be removed.

Short Code Snippet:

...

I'm trying to create a basic Sign-up and Sign-in system in python using text files. I also want the program to run in one go, meaning I want the user to be able to signup, and then proceed to log in right away, instead of having them go back and run the code again. The code that I have written though, can't do that for some reason. I've added "signin()" at the end of the sign up function to allow the users to proceed to sign in after a successful registration, but doing so throws an error. Instead I have to run the code again for the new signup to be recognized.

Here's the code:

...

Say I have a DataFrame like below

...

Summary:

I am needing to =VLOOKUP different column numbers based on the outcome of a =RIGHT statement. My current formula performs this as expected, but isn't easily scalable should I need to add more potential outcomes of the =RIGHT statement. Is there any way to scale this effectively?

Use Case:

I have a formula that inserts either "Use 1", "Use 2", "Use 3", "Use 4" or "Unknown", into Column A. Column B then need to perform a =VLOOKUP, which will vary depending on what the last character is in column A and return a different column number. For example, if cell A1 contains the text "Use 1", I will need to return the 2nd column in the =VLOOKUP. If cell A2 contains "Use 4", I will need to return the 8th column in the =VLOOKUP (the column number is non-linear).

Current Code:

=IFS(RIGHT(A2,1)="1",VLOOKUP(B2,'Table2'!A:I,2,FALSE),RIGHT(A2,1)="2",VLOOKUP(B2,'Table2'!A:I,4,FALSE),RIGHT(A2,1)="3",VLOOKUP(B2,'Table2'!A:I,5,FALSE),RIGHT(A2,1)="4",VLOOKUP(B2,'Table2'!A:I,8,FALSE),RIGHT(A2,1)="N","NotFound")

Example Table using above code:

• Code Table

Check ThingToFind Code Output Use 1 FOO ABC Use 3 BAR 012 Use 4 BAZ IN Unknown

• Table2

ThingToFind Data1 Data2 Data3 Data4 Data5 Data6 Data7 Data8 FOO ABC DEF GHI JKL MNO PQR STU VWX BAR 123 456 789 012 345 678 901 234 BAZ SOME THING TO LOOK UP GOES IN HERE

Conclusion:

The above example works fine for the previous use case, but I am trying to make this scalable without needing to edit the formula every time the Check column may get new additions (such as "Use 5" or "Use 12". Is there any way of doing this practically? My thought was to use a separate table to =VLOOKUP the column number (so I would only need to edit this table and not the formulas each time), but it appears I am unable to use a different =VLOOKUP for the COL_INDEX_NUM portion of the initial =VLOOKUP. Any help with this would be appreciated. I am using MSO 365.

...

I have four columns (Col1, Col2, Col3, Col4) in a table with some millions records in SQL Server 2019.

In stored procedure, I have to pass four input parameters @Col1, @Col2, @Col3, @Col4 and it should return success/failure whether all four values found, irrespective of column sequence. For example @Col1 can match with Col2.

Some values can be null in Col2, Col3, Col4 but Col1 will always have some data in it.

I have prepared some sample data and scenarios that I have tested.

...

I have a table that contains 3 distinct names in one field, the respective account those names are associated to, Unique IDs, the total counts for each pair, and a rank column based on the total counts value. Example here:

...

I am trying to setup a typing where I want a specific type to be resolved from an object property:

...