How to Transform Column to Row

DECLARE @InputJsonData VARCHAR(MAX) SELECT @InputJsonData='[{“MemberNumber”:8,”M1″:”2018 January”,”M1Days”:2,”M1Duration”:”2 h 54 m”,”M1Amount”:”-$712.62″,”M2″:”2018 February”,”M2Days”:5,”M2Duration”:”4 h 32 m”,”M2Amount”:”$1,359.53″},{“MemberNumber”:75,”M1″:”2018 January”,”M1Days”:2,”M1Duration”:”2 h 54 m”,”M1Amount”:”-$712.62″,”M2″:”2018 February”,”M2Days”:5,”M2Duration”:”4 h 32 m”,”M2Amount”:”$1,359.53″}]’ DECLARE @MemberDetail TABLE(MemberID VARCHAR(12),M1 VARCHAR(24),M1Days INT,M1Duration VARCHAR(24),M1Amount MONEY ,M2 VARCHAR(24),M2Days INT,M2Duration VARCHAR(24),M2Amount MONEY ) INSERT INTO @MemberDetail SELECT * FROM OPENJSON(@InputJsonData) WITH (MemberNumber VARCHAR(12) ‘$.MemberNumber’ ,M1 VARCHAR(24) ‘$.M1’ ,M1Days INT ‘$.M1Days’ ,M1Duration VARCHAR(24) ‘$.M1Duration’…

Details

Best strategy for sharing a string in a .txt file with share intent?

I have a very long string (6 MB) which I need to give to the application user. For example, sharing it by email, or storing it in any folder of the device, etc… So first I thought is to use Android’s Share Intent concept: https://developer.android.com/training/sharing/send#java Intent shareIntent = new Intent(); shareIntent.setAction(Intent.ACTION_SEND); shareIntent.putExtra(Intent.EXTRA_STREAM, uriToText); shareIntent.setType(“text/plain”); startActivity(Intent.createChooser(shareIntent,…

Details

Xamarin.Forms – MethodAccessException when calling InitializeComponent() inside main App ctor

I’m getting the following exception: System.MethodAccessException: Method Xamarin.Forms.Xaml.Diagnostics.VisualDiagnostics.RegisterSourceInfo(object,System.Uri,int,int)’ is inaccessible from method GWallet.Frontend.XF.CS.App.InitializeComponent()’ at at (wrapper managed-to-native) System.Object.__icall_wrapper_mono_throw_method_access(intptr,intptr) at GWallet.Frontend.XF.CS.App.InitializeComponent () [0x00012] in /Users/knocte/Documents/Code/geewalletFRONTENDbug/src/GWallet.Frontend.XF.CS/obj/Debug/netstandard2.0/App.xaml.g.cs:22 at GWallet.Frontend.XF.CS.App..ctor () [0x00008] in /Users/knocte/Documents/Code/geewalletFRONTENDbug/src/GWallet.Frontend.XF.CS/App.xaml.cs:10 at GWallet.Frontend.XF.Android.MainActivity.OnCreate (Android.OS.Bundle bundle) [0x00022] in /Users/knocte/Documents/Code/geewalletFRONTENDbug/src/GWallet.Frontend.XF.Android/MainActivity.fs:33 at Android.App.Activity.n_OnCreate_Landroid_os_Bundle_ (System.IntPtr jnienv, System.IntPtr native__this, System.IntPtr native_savedInstanceState) [0x00011] in <11f101b564894ca7af6c482ddc51c698>:0 at at (wrapper dynamic-method) Android.Runtime.DynamicMethodNameCounter.7(intptr,intptr,intptr) The App…

Details

Multiplying two dataframe columns result in NaN columns

I have been trying to simply multiply two dataframe columns and can’t understand why it’s not working. Here’s the code: aux = self.bars[‘Open’] pos = self.positions portfolio = pos * aux Here’s the data: print(self.bars.tail()) High Low Open Close Volume Adj Close Date 2019-12-24 321.519989 320.899994 321.470001 321.230011 20270000.0 321.230011 2019-12-26 322.950012 321.640015 321.649994 322.940002…

Details

frameToBeAvailableAndSwitchToIt() is not helping to switch to frame

I’v AJAX based application and have some frames on it and want to switch to it hence I’ve used frameToBeAvailableAndSwitchToIt() method. Suppose now I’m onframeA and want to switch to frameB using following code – WebDriverWait wait = new WebDriverWait(driver, 30); wait.until(ExpectedConditions.frameToBeAvailableAndSwitchToIt(frameB)); JavascriptExecutor jsExecutor = (JavascriptExecutor)driver; String currentFrameName = (String) jsExecutor.executeScript(“return self.name”); System.out.println(“***************** Current frame…

Details

missing 1 required positional argument: ‘dictVar’ Python

I am intro level programmer in Python. I am using an odeint function to solve system of ordinary differential equation. I am building the equation structure library(dictionary) which contain variables(a,b,c), trigonometric functions(sin,cos,tan) and arithmetic operators(+ and -) and then later on trying to optimise it using swarm intelligence algorithm. I am just mentioning the part…

Details